#!/bin/bash
dt=`date -d '-1 day' +"%Y-%m-%d"`
arr=(ads_aml_customer_risk_profile ads_aml_customer_risk_profile ads_aml_customer_risk_profile ads_aml_customer_risk_profile)
for i in ${arr[@]}; do
 sqoop export \
--connect jdbc:mysql://@192.168.65.26:3306/ms_ads \
--username root \
--password 123456 \
--table "ms_$i" \
--input-fields-terminated-by '\001' \
--input-lines-terminated-by '\n' \
--input-null-string '\\N' \
--input-null-non-string '\\N' \
--export-dir /user/hive/warehouse/ads.db/$i \
-m 1
done